﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;



namespace DAO
{
   public class LichDiDAO
    {
       public DataTable DanhSachLichDi()
       {
           DataTable dt = new DataTable();
           Data dv = new Data();
           string pname = "sp_dslichvanchuyen";
           dt=dv.ExecuteQueryNonParameter(pname);
           return dt;
       }

       public DataTable DanhSachLichDi(string sql)
       {
           DataTable dt = new DataTable();
           Data dv = new Data();
           dt = dv.ExecuteQueryWithSQLParameter(sql);
           return dt;
       }
    }
}
